So I have a bit of a situation. I am in the process of creating a database and I have come across some snags when it comes to how to manipulate the data to get the results I want.

First off I have forms created to enter the data into the table. From there I have created a report using functions to find percentages of the data as a whole. Now I want to break down the data and sort it by date, and by unit, and cound yes's and no's in order to manipulate that data I need specific functions. I have sat down and wrote out the formulas to find the answers I want, but now I need to input functions in order to get those answers on my reports. I have tried multiple functions of all kinds, nesting functions etc. I just can't seem to make this work. I know that there has to be a way, I spent a year in school learning about Access and Excel and I know that these programs are capable of manipulating the data the way I want. Could I get some suggestions and feed back on this please? If more description is needed I can gladly produce that, as well as provice snap shots of the tables to show what I mean! Thanks!

Maybe you don't need complicated functions.

You can add group levels to the report - group by date and by unit.

In the group headers, you can use a formula such as

=Count(*)

to display the number of records within that group,

=Abs(Sum([MyField]=True))

to count the number of records in the group for which the Yes/No field MyField is Yes (True), and

=Abs(Sum([MyField]=False))

to count the number for which MyField is No (False).